package edums.student.dao;

import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import java.util.Map;

import edums.employee.dto.LectureDTO;
import edums.student.dto.StudentAttendanceDTO;

public interface StudentAttendanceDAO {
	
	public abstract List seleactLectureList(Map searchInfo) throws SQLException;
	
	public int selectLectureListTotalContent(Map searchInfo) throws SQLException;
	
	public abstract LectureDTO selectLecture(String lectureId)
			throws SQLException;

	public abstract void insertStudentAttendance(StudentAttendanceDTO sadto)
			throws SQLException;

	public abstract void updateStudentAttendance(Map studentAttendanceInfo)
			throws SQLException;

	public abstract List selectAllStudentAttendance(Map studentAttendanceInfo)
			throws SQLException;

	public abstract List selectStudentAttendanceDateYear(
			Map studentAttendanceInfo) throws SQLException;

	public abstract List selectStudentAttendanceDateMonth(
			Map studentAttendanceInfo) throws SQLException;
	
	public abstract int selectStudentAttendanceTotalContent(
			Map studentAttendanceInfo) throws SQLException;

	public abstract StudentAttendanceDTO selectStudentAttendance(
			Map studentAttendanceInfo) throws SQLException;

	public abstract Map selectLectureTime(Map searchInfo) throws SQLException;
}